﻿CREATE TABLE [Core].[Authorization] (
    [AuthorizationId] UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [UserId]          UNIQUEIDENTIFIER NOT NULL,
    [RoleId]          UNIQUEIDENTIFIER NULL,
    [PermissionId]    UNIQUEIDENTIFIER NULL,
    [IsDroppedYN]     NCHAR (1)        NOT NULL,
    [CreateDT]        DATETIME         NOT NULL,
    [CreatedById]     UNIQUEIDENTIFIER NOT NULL,
    [CreatedByName]   NVARCHAR (127)   NOT NULL,
    [ModifiedDT]      DATETIME         NOT NULL,
    [ModifiedById]    UNIQUEIDENTIFIER NOT NULL,
    [ModifiedByName]  NVARCHAR (127)   NOT NULL
);

